KS_CUSTOMERS

Ordinal

Description

1

Customer Number

Must be unique to the ERP system

2

KommerceServer ID

This is the KommerceServer reference number for this customer. It is only needed when the customer was originally created in KS as a cross reference to the customer number assigned by the ERP system when imported.

3

Business Type

'C' = customer

Vendors, prospects, and end users reside in same table with different types

5

Address Line 1

There is only one address which can be sent for each unique customer which is flagged in the SQL DB as the primary or corporate address. Addition location addresses are sent up separately via the KS_SHIP_ADDRS data feed. The Country is a free form string but for best results, send up the ISO standard 2-character country code. KommerceServer will match this to an internal table so that the country can be maintained through a drop down list when adding or updating address locations.

6

Address Line 2

7

Address Line 3

8

City

9

State

10

Zip Code

11

Country

12

Phone

13

Site ID

The site or warehouse codes will be created if they don’t exist. They are also defined in the KS_INVENTORY export

14

Site Name

15

Website

The customer's website URL. This is a linkable field in KommerceServer so it should be fully qualified URL

16

Credit Limit

Display only reference field

17

Terms Type XREF

Cross reference value (e.g. 2/5/30); A payment term will be created if it does not exist.

18

KS Term Type

'STD'=Standard 'PREPAID'= Prepaid
(Credit Card on web)
'COD'=Cash on Delivery
'PROX'= Discount based on day of month
'STDX'=Terms but use the XREF for display

If 'PREPAID' type the discount term fields below can be null; If 'STDX' is used then the breakdown fields do not need to be supplied (e.g. discount day, discount %, etc.)

19

Discount Days

The max number of days aged before discount expires (STD type)

20

Discount Day of Month

The day of the following month when discount can be taken (PROX type)

21

Discount Percent

Discount percentage (factor) if paid early

22

Discount Net Days

If not paid early, the days when the net balance will be due (STD type)

23

Net Discount Day of Month

If not paid early, the day of the next month when balance will be due (PROX)

24

Taxable

'Y' = Taxable
business
'N' = Not taxable (e.g. reseller)

If Non-Taxable, then tax will never be computed on orders regardless of where it is shipping

25

Tax Code

FK Table sent by KS_SALES_TAX export

26

Master Reference Id

Used to logically group multiple customers into one virtual customer

27

Sales Representative

Sales reps show as links on website only if there is a corresponding contact exported with this sales rep code.

28

Currency Code

If NULL, the functional currency of the website is assumed

29

Bill To Customer Number

Self reference FK which means the bill to customer also needs to be sent in the same data export as the rest of the customers (Business Type = 'C')

30

Region

Refer to KS_REGIONS export

31

Customer Class

Refer to KS_CLASSIFICATIONS export

32

Credit Hold

A Non-null value indicates the customer is on Hold

33

Price Sheet Code

When determining item prices in the storefront this is used to identify customer specific pricing. A Price Sheet Code can be any string but should represent how your ERP system organizes pricing. For example, if by country you may opt to send in the ISO country code. If your system has this concept it is best to send in a relevant value. For example, if there is a branch where pricing is derived then send in the branch identifier. KommerceServer does not care what this value is but it will use this as a first-level filter when looking up customer pricing.

34

Price Basis Code

A secondary filter can be used for customer-specific price lookups. There can be more than one Price Basis per Price Sheet (e.g. LIST, WHOLESALE, MSRP, COST, etc.). If your ERP just has one price per Price Sheet, then use a meaningful term like LIST or BASE for this field. This field can be left blank but if there are more 1 price defined for a Price Sheet it will be ambiguous so pricing cannot be determined.

35

Matrix Group Values

Use "&" to delimit between pairs and use "=" to match
a Group to a Value. If a Group has multiple values then use the "," separator between values.

This is a JSON formatted string of named value pairs which will be parsed and optimized exclusively for the purposes of price matrix selection. Any associated group value that may participate in a price matrix should be included for the customer. For example, if you provide price matrix discounts based on a specific class of customer, specific customer, a specific region, or zip code, the string may look like:
"CUST_CLASS":["ABC","XYZ"],"CUST_ID":"123","REGION":"NORTHWEST","ZIP":"92123" Note: GROUP names should be consistent between customers but the group VALUES may obviously vary between customers.

36

Access Group Codes

Specifies the Access Group Code for the customer.

37

Default Ship Via

Indicates a default Ship Via code for the customer. During checkout in the Store is there is a freight method that is associated to this ship via code, it will be the default.

38

Free Shipping Minimum

Indicates a minimum dollar amount required for free shipping for this customer. Only those freight methods that are eligible for a customer-specific minimum will this feature be applied.

Note: You must send up a number greater then 0 for this feature to be active.